SyServiceException

Logical Entity Name | SyServiceException
Default Table Name | SyServiceException
Physical Only | NO
Owner | dbo
Definition |
Note |

SyServiceException Columns

ColumnName | Domain | Datatype | NULL | Definition
SyServiceExceptionId |  | int | NO |
SyServiceExceptionTemplateId |  | int | NO |
SyServiceExceptionStatusId |  | int | NO |
SyServiceExceptionActionId |  | int | NO |
ExceptionHashId |  | numeric(20, 0) | NO |
SourceRecordHashId |  | numeric(20, 0) | YES |
ExceptionDetail |  | xml | NO |
Comment |  | nvarchar(max) | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
SnoozeUntil |  | datetime | YES |
ExpiresOn |  | datetime | YES |
SyCampusId |  | int | YES |
CountNbr |  | int | NO |

SyServiceException Primary and Unique Keys

Key Name | Key Type | Keys
Uk_SyServiceException_ExceptionHashId | Index | ExceptionHashId
Pk_SyServiceException_SyServiceExceptionID | PrimaryKey | SyServiceExceptionId

SyServiceException Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SyCampus | Non-Identifying | Zero or One to Zero or More | FK_SyServiceException_SyCampus_SyCampusId |  |  | SyCampusId | NO | YES
SyServiceExceptionAction | Non-Identifying | One To Zero or More | FK_SyServiceExceptionSyServiceExceptionActionId_SyServiceExceptionActionSyServiceExceptionActionId |  |  | SyServiceExceptionActionId | NO | YES
SyServiceExceptionStatus | Non-Identifying | One To Zero or More | FK_SyServiceExceptionSyServiceExceptionStatusId_SyServiceExceptionStatusSyServiceExceptionStatusId |  |  | SyServiceExceptionStatusId | NO | YES
SyServiceExceptionTemplate | Non-Identifying | One To Zero or More | FK_SyServiceExceptionSyServiceExceptionTemplateId_SyServiceExceptionTemplateSyServiceExceptionTemplateId |  |  | SyServiceExceptionTemplateId | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_SyServiceExceptionUserID_SyStaffSyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
SyServiceExceptionDailyPerformanceDetail | Non-Identifying | One To Zero or More | FK_SyServiceExceptionDailyPerformanceDetailExceptionHashId_SyServiceExceptionExceptionHashId |  |  |  | NO | YES
SyServiceExceptionOcurrence | Non-Identifying | One To Zero or More | FK_SyServiceExceptionOcurrenceSyServiceExceptionID_SyServiceExceptionSyServiceExceptionID |  |  |  | NO | YES
SyServiceExceptionRouting | Non-Identifying | One To Zero or More | FK_SyServiceExceptionRoutingSyServiceExceptionId_SyServiceExceptionSyServiceExceptionId |  |  |  | NO | YES

SyServiceException Check Constraints

Check Constraint Name | CheckConstraint

SyServiceException Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

SyServiceException Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaaProcessException | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyServiceException | NO |  |  |

SyServiceException Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Service

SyServiceException Data Movement Rules

Name | Type | Rule Text/Value